package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_bs_ord", simpleName = "", engine = MysqlDriver.InnoDB, comment = "")
public class _DDL_CBsOrd {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "订单id")
    private java.math.BigInteger id;

    @_DDL_Index(name = "IDX_c_bs_ord_bs_id")
    @_DDL_Column(name = "bs_id", type = SqlType.INT_UNSIGNED, comment = "商户id")
    private Long bsId;

    @_DDL_Index(name = "IDX_c_bs_ord_date")
    @_DDL_Column(name = "date", type = SqlType.INT_UNSIGNED, comment = "日期")
    private Long date;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "amt", type = SqlType.DECIMAL, size = 8, scale = 2, comment = "消费金额")
    private java.math.BigDecimal amt;

    @_DDL_Column(name = "usr_id", type = SqlType.INT_UNSIGNED, comment = "用户id")
    private Long usrId;

    @_DDL_Column(name = "coupon", type = SqlType.DECIMAL, size = 8, scale = 2, comment = "优惠")
    private java.math.BigDecimal coupon;

}
